package com.dvd.utils;

public class MakeSql {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		
			makeDvdInsert();
	}
	
	public static void makeDvdInsert()
	{

		for(int i=1;i<20;i++)
		{
			String sql=new String("insert into T_DVD " +
			
			"values('{id}','{title}',{year},'{type}','{courntry}',{price},'{imgpath}','{director}'," +
			"'{actor}','{meno}','{crtdt}','{upddt}');");
			sql=sql.replace("{id}", ""+i).
			replace("{title}","dvd"+i).
			replace("{price}",""+i*1000).
			replace("{crtdt}","2008-10-20").
			replace("{upddt}","2009-10-22").
			replace("{year}", ""+i*100).
			replace("{imgpath}", "uploadimages/"+i+".jpg");
			System.out.println(sql);
			
		}
	}

}
